Tandem's Log
Created: 5/31/2007 5:53:03 PM
<< 10/2008 < 10/2007 Calendar 11/2009 > 10/2010 >>Sign InView Other Logs
Sun 
08/02/2009 09:34:03
 jim  Macro to save a file on change
?tacl macro
== ****************************************************************************
== * Macro  : ZCOLLECT                                                        *
== * Purpose: To save a file each time its modification date changes          *
== * Syntax : RUN ZCOLLECT SourceFile SaveFile Beg End                        *
== * Example: run zcollect $DATA.LOGFILE.LOG $DATA.SAVEFILE.LOG 20 25         *
== *          -------------------------------------------------------         *
== * Narrative:                                                               *
== * Check $DATA.LOGFILE.LOG's timestamp against $DATA.SAVEFILE.LOG20         *
== * If its different, it will                                                *
== *          fup dup $DATA.LOGFILE.LOG, $DATA2.SAVEFILE.LOG20,sourcedate     *
== * It will then set up for -> $DATA.SAVEFILE.LOG21                          *
== ****************************************************************************
#push SourceFile SaveFile BegAt EndAt
#set  SourceFile %1%
#set  SaveFile   %2%
#set  BegAt      %3%
#set  EndAt      %4%

[#if ([#fileinfo/existence/[SaveFile][BegAt]])
|then|
==  The first file already exists. Do nothing.
|else|
==  Grab the first file
    fup dup [SourceFile],[SaveFile][BegAt],sourcedate
]
 
[#loop |do|
   [#if (
        [#fileinfo/modification/[SourceFile]] =
        [#fileinfo/modification/[SaveFile][BegAt]]
        )
   |then|
       delay 5 mins == This pause can be mins, hours or secs
   |else|
       #set  BegAt [#compute [BegAt] + 1]
       #output fup dup [SourceFile],[SaveFile][BegAt],sourcedate
       fup dup [SourceFile],[SaveFile][BegAt],sourcedate
   ]
|until| (BegAt = EndAt)
]
Tue 
06/17/2008 05:24:35
 jim  Tmf auto aborts an entire batch after 1 error
MX Sql automatically aborts a batch of transactions after an IUD (Insert, Update, Delete).
IUD - I wonder who came up with that abbreviation...lol.
So, when loading a database, you might lose 50,000 inserts for 1 referential integrety error. This is unacceptable for a data base with terabytes of data. To get around this, set :
UPD_ABORT_ON_ERROR to off.
To check that setting:
display_explain options 'f' my_query;
The OPT column displays token upd_action_on_error: on_rollback. A value of "x" means that the transaction will be rolled back.
If this solution doesn't work for some reason, all I can see are two options:
1 - Turn Audit off on the target database. That would slow down the load though.
2 - Table up all the batched transactions, and write them to a restart file whenever an error occurs.
Tue 
05/20/2008 21:50:24
 Tandem  Unix Commands

Unix commands reference card


Environment Control

Command                     Description
cd d Change to directory d
mkdir d Create new directory d
rmdir d Remove directory d
mv f1 [f2...] d Move file f to directory d
mv d1 d2 Rename directory d1 as d2
passwd Change password
alias name1 name2 Create command alias (csh/tcsh)
alias name1="name2" Create command alias (ksh/bash)
unalias name1[na2...] Remove command alias na
ssh nd Login securely to remote node
exit End terminal session
setenv name v Set env var to value v (csh/tcsh)
export name="v" set environment variable to value v (ksh/bash)

Output, Communication, & Help

Command                     Description
lpr -P printer f
lp -d printer f Output file f to line printer
script [f] Save terminal session to
exit Stop saving terminal session
mailx username Send mail to user
man name Unix manual entry for name

Process Control

Command                     Description
CTRL/c * Interrupt processes
CTRL/s * Stop screen scrolling
CTRL/q * Resume screen output
sleep n Sleep for n seconds
jobs Print list of jobs
kill % Kill job n
ps Print process status stats
kill -9 n Remove process n
CTRL/z * Suspend current process
stop %n Suspend background job n
cmmd& Run cmmd in background
bg [%n] Resume background job n
fg [%n] Resume foreground job n
exit Exit from shell

Environment Status

Command                     Description
ls [d] [f...] List files in directory
ls -1 [f...] List files in detail
alias [name] Display command aliases
printenv [name] Print environment values
quota Display disk quota
date Print date & time
who List logged in users
whoami Display current user
finger [username] Output user information
chfn Change finger information
pwd Print working directory
history Display recent commands
! n Submit recent command n

File Manipulation

Command                     Description
vi [f] Vi fullscreen editor
emacs [f] Emacs fullscreen editor
ed [f] Text editor
wc f Line, word, & char count
cat f List contents of file
more f List file contents by screen
cat f1 f2 >f3 Concatenates f1 & f2 into f3
chmod mode f Change protection mode of f
cmp f1 f2 Compare two files
cp f1 f2 Copy file f1 into f2
sort f Alphabetically sort f
split [-n] f Split f into n-line pieces
mv f1 f2 Rename file f1 as f2
rm f Delete (remove) file f
grep 'ptn' f Outputs lines that match ptn
diff f1 f2 Lists file differences
head f Output beginning of f
tail f Output end of f

Compiler

Command                     Description
cc [-o f1] f2 C compiler
lint f Check C code for errors
f77 [-o f1] f2 Fortran77 compiler
pc [-o f1] f2 Pascal compiler

Working with NFS files

Files saved on the UITS central Unix computers Steel, the Parallel PC cluster, Solar/Lunar, and the Research SP are stored on the Network File Server (NFS). That means that your files are really on one disk, in directories named for the central Unix hosts on which you have accounts. No matter which of these computers you are logged into, you can get to your files on any of the others. Here are the commands to use to get to any system directory from any other system:
  cd /N/u/username/PPPC/
cd /N/u/username/Cobalt/
cd /N/u/username/Solar/
cd /N/u/username/Steel/
cd /n/u/username/SP/
Be sure you use the capitalization just as you see above, and substitute your own username for "username".
For example, if Jessica Rabbit is logged into her account on Steel, and wants to get a file on her SP account, she would enter:
  cd /N/u/jrabbit/SP/
Now when she lists her files, she'll see her SP files, even though she's actually logged into Steel. You can use the ordinary Unix commands to move files, copy files, or make symbolic links between files. For example, if Jessica Rabbit wanted to move "file1" from her Steel directory to her SP directory, she would enter:
  mv -i /N/u/jrabbit/Steel/file1 /N/u/jrabbit/SP/
This shared file system means that you can access, for example, your SP files even when you are logged into Steel, and vice versa. However, if you are logged into the SP, you can only use the software installed on SP -- only users' directories are linked together, not system directories.

Abbreviations used in this document

CTRL/x       hold down control key and press x
d directory
env environment
f filename
n number
nd computer node
prtr printer
ptn pattern
var variable
[y/n] yes or no
[] optional arg
... list

Printing this how-to guide

PDF iconA printable version of this guide is available in Adobe Acrobat's Portable Document Format (PDF). To print the PDF file, you need special software, such as the Acrobat Reader or the Acrobat Netscape plug-in. Everything you need for this is in the UITS Student Technology Centers. If you have trouble accessing a PDF file, notify the lab consultant. If you're at a personal computer and don't have the necessary software, you can download and install the Acrobat reader on your system. You'll need to do this step only once. To print this guide:
  1. Download Unix commands: A quick guide (Acrobat/pdf format).
  2. Use Acrobat to print the document.
If you wish to print this guide from your browser, please consult the browser's printing instructions.

Last updated: August 2000
http://www.indiana.edu/~uitspubs/b017/
Comments: ithelp@indiana.edu
Copyright 1995-2000, The Trustees of Indiana University

Tue 
10/09/2007 17:46:15
 jim  Programming Manuals

<< 10/2008 < 10/2007 Calendar 11/2009 > 10/2010 >>Sign InView Other Logs